<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

	<!-- 
	        督办事项办理信息表
	   create by xiao.aohan@163.com
	-->
<hibernate-mapping>
    <class name="cn.firstsoft.modules.inspect.domain.InspectProceedInfo" table="inspect_proceed_info" >
        <id name="id" type="integer">
            <column name="id" /> 
            <generator class="native" >
				<param name="sequence">INSPECT_PROCEED_INFO_ID_SEQ</param>
            </generator>
        </id>
        <property name="type" type="string">
            <column name="type" length="10"/>
        </property>
        <property name="deferDate" type="timestamp">
            <column name="defer_date"/>
        </property>
        <property name="createId" type="integer">
            <column name="create_id" />
        </property>
        <property name="createTime" type="timestamp">
            <column name="create_time" />
        </property>
        <property name="updateId" type="integer">
            <column name="update_id" />
        </property>
        <property name="updateTime" type="timestamp">
            <column name="update_time" />
        </property>
        <property name="descn" type="string">
            <column name="descn" length="2000"/>
        </property>
        <property name="progress" type="integer">
            <column name="progress"/>
        </property>
        <many-to-one name="user" class="org.springside.modules.security.domain.User" fetch="select">
            <column name="user_id" />
        </many-to-one>
        <many-to-one name="inspectUser" class="cn.firstsoft.modules.inspect.domain.InspectUser" fetch="select">
            <column name="inspect_user_id"/>
        </many-to-one>
        <many-to-one name="workflowSignature" class="cn.firstsoft.modules.workflow.domain.WorkflowSignature" fetch="select">
            <column name="workflow_sign_id" />
        </many-to-one>
        <many-to-one name="inspectProceed" class="cn.firstsoft.modules.inspect.domain.InspectProceed" fetch="select">
            <column name="inspect_proceed_id" />
        </many-to-one>
        <set name="fileAttach" table="inspect_proceed_attach" sort="natural" lazy="true" inverse="true" cascade="none" batch-size="20">
            <key>
                <column name="inspect_proceed_info_id"/>
            </key>
            <one-to-many class="cn.firstsoft.modules.inspect.domain.InspectProceedAttach"/>
        </set>
    </class>
</hibernate-mapping>
